create procedure [dbo].[BAECustom_GetUserInfoForFormLoad] @uID varchar(8) as
SELECT    n.FIRST_NAME,
        n.LAST_NAME,
        n.HOME_PHONE,
        n.EMAIL,
        na.ADDRESS_1,
        na.ADDRESS_2,
        na.ADDRESS_3,
        na.CITY,
        na.STATE_PROVINCE,
        na.ZIP

FROM        Name n INNER JOIN
        Name_Address na ON n.MAIL_ADDRESS_NUM = na.ADDRESS_NUM

WHERE    @uID = n.ID

GO